Earthquake Data Profiling Report

Dataset statistics

Number of variables	12
Number of observations	3445751
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	16865
Duplicate rows (%)	0.5%
Total size in memory	315.5 MiB
Average record size in memory	96.0 B

Variable types

Numeric	7
Text	5

Alerts

Dataset has 16865 (0.5%) duplicate rows	Duplicates
`latitude` is highly overall correlated with `longitude`	High correlation
`longitude` is highly overall correlated with `latitude`	High correlation
`magnitudo` is highly overall correlated with `significance`	High correlation
`significance` is highly overall correlated with `magnitudo`	High correlation
`tsunami` is highly skewed (γ1 = 47.45603279)	Skewed
`tsunami` has 3444223 (> 99.9%) zeros	Zeros
`significance` has 163607 (4.7%) zeros	Zeros
`depth` has 63714 (1.8%) zeros	Zeros

Reproduction

Analysis started	2024-07-01 09:49:08.506394
Analysis finished	2024-07-01 09:50:28.563159
Duration	1 minute and 20.06 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

time
Real number (ℝ)

Distinct	3428775
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2471236 × 10¹²

Minimum	6.3115335 × 10¹¹
Maximum	1.6906289 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	6.3115335 × 10¹¹
5-th percentile	7.1656794 × 10¹¹
Q1	1.024401 × 10¹²
median	1.2823381 × 10¹²
Q3	1.5087006 × 10¹²
95-th percentile	1.6528453 × 10¹²
Maximum	1.6906289 × 10¹²
Range	1.0594756 × 10¹²
Interquartile range (IQR)	4.8429956 × 10¹¹

Descriptive statistics

Standard deviation	2.9762923 × 10¹¹
Coefficient of variation (CV)	0.23865256
Kurtosis	-1.0314874
Mean	1.2471236 × 10¹²
Median Absolute Deviation (MAD)	2.4116381 × 10¹¹
Skewness	-0.34090832
Sum	4.2972773 × 10¹⁸
Variance	8.8583161 × 10²²
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.646264543 × 10¹²	4	< 0.1%
1.646108994 × 10¹²	4	< 0.1%
9.4392 × 10¹¹	3	< 0.1%
9.20361823 × 10¹¹	2	< 0.1%
7.309523597 × 10¹¹	2	< 0.1%
7.309458786 × 10¹¹	2	< 0.1%
7.309471246 × 10¹¹	2	< 0.1%
7.309479143 × 10¹¹	2	< 0.1%
7.30947942 × 10¹¹	2	< 0.1%
7.309479584 × 10¹¹	2	< 0.1%
Other values (3428765)	3445726	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.31153354 × 10¹¹	1	< 0.1%
6.311534912 × 10¹¹	1	< 0.1%
6.311540834 × 10¹¹	1	< 0.1%
6.311555121 × 10¹¹	1	< 0.1%
6.311558245 × 10¹¹	1	< 0.1%
6.311558538 × 10¹¹	1	< 0.1%
6.311560306 × 10¹¹	1	< 0.1%
6.31156432 × 10¹¹	1	< 0.1%
6.311566141 × 10¹¹	1	< 0.1%
6.311566202 × 10¹¹	1	< 0.1%

Value	Count	Frequency (%)
1.690628938 × 10¹²	1	< 0.1%
1.690628146 × 10¹²	1	< 0.1%
1.690627216 × 10¹²	1	< 0.1%
1.690626976 × 10¹²	1	< 0.1%
1.690626852 × 10¹²	1	< 0.1%
1.690626816 × 10¹²	1	< 0.1%
1.690626699 × 10¹²	1	< 0.1%
1.690626164 × 10¹²	1	< 0.1%
1.690625393 × 10¹²	1	< 0.1%
1.69062531 × 10¹²	1	< 0.1%

place
Text

Distinct	531130
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	26.3 MiB

Length

Max length	67
Median length	62
Mean length	29.292777
Min length	4

Characters and Unicode

Total characters	100935617
Distinct characters	150
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	317021 ?
Unique (%)	9.2%

Sample

1st row	12 km NNW of Meadow Lakes, Alaska
2nd row	14 km S of Volcano, Hawaii
3rd row	7 km W of Cobb, California
4th row	11 km E of Mammoth Lakes, California
5th row	16km N of Fillmore, CA

Value	Count	Frequency (%)
of	3305714	15.8%
km	2535408	12.1%
california	879763	4.2%
alaska	811447	3.9%
ca	491702	2.3%
w	285248	1.4%
ese	250426	1.2%
e	241915	1.2%
cobb	232631	1.1%
wnw	222386	1.1%
Other values (28691)	11719370	55.9%

Most occurring characters

Value	Count	Frequency (%)
	17530358	17.4%
a	8289995	8.2%
o	7009091	6.9%
k	4907137	4.9%
i	4370976	4.3%
f	4318286	4.3%
m	3846973	3.8%
l	3831250	3.8%
n	3800284	3.8%
,	3362018	3.3%
Other values (140)	39669249	39.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100935617	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	17530358	17.4%
a	8289995	8.2%
o	7009091	6.9%
k	4907137	4.9%
i	4370976	4.3%
f	4318286	4.3%
m	3846973	3.8%
l	3831250	3.8%
n	3800284	3.8%
,	3362018	3.3%
Other values (140)	39669249	39.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100935617	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	17530358	17.4%
a	8289995	8.2%
o	7009091	6.9%
k	4907137	4.9%
i	4370976	4.3%
f	4318286	4.3%
m	3846973	3.8%
l	3831250	3.8%
n	3800284	3.8%
,	3362018	3.3%
Other values (140)	39669249	39.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100935617	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	17530358	17.4%
a	8289995	8.2%
o	7009091	6.9%
k	4907137	4.9%
i	4370976	4.3%
f	4318286	4.3%
m	3846973	3.8%
l	3831250	3.8%
n	3800284	3.8%
,	3362018	3.3%
Other values (140)	39669249	39.3%

status
Text

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.3 MiB

Length

Max length	9
Median length	8
Mean length	8.0600151
Min length	6

Characters and Unicode

Total characters	27772805
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	reviewed
2nd row	reviewed
3rd row	reviewed
4th row	reviewed
5th row	reviewed

Value	Count	Frequency (%)
reviewed	3238918	94.0%
automatic	206821	6.0%
manual	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	9674475	34.8%
i	3430539	12.4%
r	3224825	11.6%
v	3224825	11.6%
w	3224825	11.6%
d	3224825	11.6%
a	411444	1.5%
t	411428	1.5%
u	205722	0.7%
m	205722	0.7%
Other values (18)	534175	1.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	27772805	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	9674475	34.8%
i	3430539	12.4%
r	3224825	11.6%
v	3224825	11.6%
w	3224825	11.6%
d	3224825	11.6%
a	411444	1.5%
t	411428	1.5%
u	205722	0.7%
m	205722	0.7%
Other values (18)	534175	1.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	27772805	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	9674475	34.8%
i	3430539	12.4%
r	3224825	11.6%
v	3224825	11.6%
w	3224825	11.6%
d	3224825	11.6%
a	411444	1.5%
t	411428	1.5%
u	205722	0.7%
m	205722	0.7%
Other values (18)	534175	1.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	27772805	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	9674475	34.8%
i	3430539	12.4%
r	3224825	11.6%
v	3224825	11.6%
w	3224825	11.6%
d	3224825	11.6%
a	411444	1.5%
t	411428	1.5%
u	205722	0.7%
m	205722	0.7%
Other values (18)	534175	1.9%

tsunami
Real number (ℝ)

SKEWED ZEROS

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.00044344469

Minimum	0
Maximum	1
Zeros	3444223
Zeros (%)	> 99.9%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.02105346
Coefficient of variation (CV)	47.477082
Kurtosis	2250.0764
Mean	0.00044344469
Median Absolute Deviation (MAD)	0
Skewness	47.456033
Sum	1528
Variance	0.00044324818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=2)

Value	Count	Frequency (%)
0	3444223	> 99.9%
1	1528	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3444223	> 99.9%
1	1528	< 0.1%

Value	Count	Frequency (%)
1	1528	< 0.1%
0	3444223	> 99.9%

significance
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1170
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	74.009735

Minimum	0
Maximum	2910
Zeros	163607
Zeros (%)	4.7%
Negative	0
Negative (%)	0.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	13
median	33
Q3	81
95-th percentile	312
Maximum	2910
Range	2910
Interquartile range (IQR)	68

Descriptive statistics

Standard deviation	101.63641
Coefficient of variation (CV)	1.3732844
Kurtosis	7.8921127
Mean	74.009735
Median Absolute Deviation (MAD)	25
Skewness	2.2677209
Sum	2.5501912 × 10⁸
Variance	10329.961
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	163607	4.7%
19	102393	3.0%
26	99265	2.9%
12	94934	2.8%
30	93288	2.7%
22	87397	2.5%
15	82901	2.4%
39	79131	2.3%
10	77096	2.2%
35	77068	2.2%
Other values (1160)	2488671	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	163607	4.7%
1	76140	2.2%
2	59133	1.7%
3	43505	1.3%
4	68084	2.0%
5	44653	1.3%
6	63513	1.8%
7	28312	0.8%
8	66326	1.9%
9	32329	0.9%

Value	Count	Frequency (%)
2910	2	< 0.1%
2841	1	< 0.1%
2820	1	< 0.1%
2790	1	< 0.1%
2760	1	< 0.1%
2676	1	< 0.1%
2505	1	< 0.1%
2495	1	< 0.1%
2469	1	< 0.1%
2397	1	< 0.1%

data_type
Text

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.3 MiB

Length

Max length	26
Median length	10
Mean length	10.016039
Min length	6

Characters and Unicode

Total characters	34512778
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	earthquake
2nd row	earthquake
3rd row	earthquake
4th row	earthquake
5th row	earthquake

Value	Count	Frequency (%)
earthquake	3361846	96.0%
quarry	38880	1.1%
blast	38865	1.1%
explosion	29128	0.8%
ice	13839	0.4%
quake	13839	0.4%
mining	2177	0.1%
event	1707	< 0.1%
other	1706	< 0.1%
chemical	314	< 0.1%
Other values (24)	759	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	6815708	19.7%
e	6786118	19.7%
r	3441788	10.0%
u	3414823	9.9%
q	3414564	9.9%
t	3404362	9.9%
k	3375870	9.8%
h	3363867	9.7%
l	68452	0.2%
s	68315	0.2%
Other values (18)	358911	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34512778	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	6815708	19.7%
e	6786118	19.7%
r	3441788	10.0%
u	3414823	9.9%
q	3414564	9.9%
t	3404362	9.9%
k	3375870	9.8%
h	3363867	9.7%
l	68452	0.2%
s	68315	0.2%
Other values (18)	358911	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34512778	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	6815708	19.7%
e	6786118	19.7%
r	3441788	10.0%
u	3414823	9.9%
q	3414564	9.9%
t	3404362	9.9%
k	3375870	9.8%
h	3363867	9.7%
l	68452	0.2%
s	68315	0.2%
Other values (18)	358911	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34512778	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	6815708	19.7%
e	6786118	19.7%
r	3441788	10.0%
u	3414823	9.9%
q	3414564	9.9%
t	3404362	9.9%
k	3375870	9.8%
h	3363867	9.7%
l	68452	0.2%
s	68315	0.2%
Other values (18)	358911	1.0%

magnitudo
Real number (ℝ)

HIGH CORRELATION

Distinct	933
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7740761

Minimum	-9.99
Maximum	9.1
Zeros	23097
Zeros (%)	0.7%
Negative	88715
Negative (%)	2.6%
Memory size	26.3 MiB

Quantile statistics

Minimum	-9.99
5-th percentile	0.2
Q1	0.91
median	1.46
Q3	2.3
95-th percentile	4.5
Maximum	9.1
Range	19.09
Interquartile range (IQR)	1.39

Descriptive statistics

Standard deviation	1.2910551
Coefficient of variation (CV)	0.72773376
Kurtosis	1.6953256
Mean	1.7740761
Median Absolute Deviation (MAD)	0.64
Skewness	0.84296237
Sum	6113024.6
Variance	1.6668233
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.4	85212	2.5%
1.1	81829	2.4%
1.3	81765	2.4%
1.2	76955	2.2%
1.6	71650	2.1%
1.5	69262	2.0%
1	64506	1.9%
0.9	57673	1.7%
1.7	57007	1.7%
1.8	55929	1.6%
Other values (923)	2743963	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9.99	617	< 0.1%
-9	29	< 0.1%
-5	1	< 0.1%
-2.6	2	< 0.1%
-2.5	4	< 0.1%
-2.2	1	< 0.1%
-2	4	< 0.1%
-1.9	5	< 0.1%
-1.82	1	< 0.1%
-1.8	6	< 0.1%

Value	Count	Frequency (%)
9.1	2	< 0.1%
8.8	1	< 0.1%
8.6	2	< 0.1%
8.4	2	< 0.1%
8.3	4	< 0.1%
8.2	6	< 0.1%
8.16	1	< 0.1%
8.1	7	< 0.1%
8.09	1	< 0.1%
8	7	< 0.1%

state
Text

Distinct	858
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.3 MiB

Length

Max length	54
Median length	53
Mean length	9.4404744
Min length	3

Characters and Unicode

Total characters	32529524
Distinct characters	63
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	106 ?
Unique (%)	< 0.1%

Sample

1st row	Alaska
2nd row	Hawaii
3rd row	California
4th row	California
5th row	California

Value	Count	Frequency (%)
california	1371023	35.2%
alaska	797244	20.5%
nevada	177078	4.5%
hawaii	125336	3.2%
washington	82385	2.1%
islands	69799	1.8%
utah	57203	1.5%
montana	53899	1.4%
indonesia	48502	1.2%
puerto	47879	1.2%
Other values (597)	1064227	27.3%

Most occurring characters

Value	Count	Frequency (%)
a	6036019	18.6%
i	3677804	11.3%
	3272283	10.1%
l	2467807	7.6%
n	2326249	7.2%
o	2023837	6.2%
r	1758548	5.4%
C	1493421	4.6%
f	1421221	4.4%
s	1236961	3.8%
Other values (53)	6815374	21.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	32529524	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	6036019	18.6%
i	3677804	11.3%
	3272283	10.1%
l	2467807	7.6%
n	2326249	7.2%
o	2023837	6.2%
r	1758548	5.4%
C	1493421	4.6%
f	1421221	4.4%
s	1236961	3.8%
Other values (53)	6815374	21.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	32529524	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	6036019	18.6%
i	3677804	11.3%
	3272283	10.1%
l	2467807	7.6%
n	2326249	7.2%
o	2023837	6.2%
r	1758548	5.4%
C	1493421	4.6%
f	1421221	4.4%
s	1236961	3.8%
Other values (53)	6815374	21.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	32529524	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	6036019	18.6%
i	3677804	11.3%
	3272283	10.1%
l	2467807	7.6%
n	2326249	7.2%
o	2023837	6.2%
r	1758548	5.4%
C	1493421	4.6%
f	1421221	4.4%
s	1236961	3.8%
Other values (53)	6815374	21.0%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	733599
Distinct (%)	21.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-101.28763

Minimum	-179.9997
Maximum	180
Zeros	17
Zeros (%)	< 0.1%
Negative	3066668
Negative (%)	89.0%
Memory size	26.3 MiB

Quantile statistics

Minimum	-179.9997
5-th percentile	-162.7131
Q1	-146.4274
median	-118.95383
Q3	-115.92767
95-th percentile	126.364
Maximum	180
Range	359.9997
Interquartile range (IQR)	30.499733

Descriptive statistics

Standard deviation	76.974157
Coefficient of variation (CV)	-0.75995615
Kurtosis	4.6265558
Mean	-101.28763
Median Absolute Deviation (MAD)	6.59
Skewness	2.3316125
Sum	-3.4901195 × 10⁸
Variance	5925.0208
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.8103333	784	< 0.1%
-122.7963333	703	< 0.1%
-117.68	621	< 0.1%
-122.8125	617	< 0.1%
-116.468	583	< 0.1%
-116.465	573	< 0.1%
-116.462	573	< 0.1%
-116.47	573	< 0.1%
-116.466	568	< 0.1%
-116.467	568	< 0.1%
Other values (733589)	3439588	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-179.9997	1	< 0.1%
-179.999	6	< 0.1%
-179.9989	1	< 0.1%
-179.9987	1	< 0.1%
-179.9986	1	< 0.1%
-179.9985	3	< 0.1%
-179.9983	2	< 0.1%
-179.9982	2	< 0.1%
-179.998	4	< 0.1%
-179.9978	1	< 0.1%

Value	Count	Frequency (%)
180	8	< 0.1%
179.9999	2	< 0.1%
179.9994	1	< 0.1%
179.9993	4	< 0.1%
179.999	8	< 0.1%
179.9989	1	< 0.1%
179.9988	1	< 0.1%
179.9986	1	< 0.1%
179.9983	1	< 0.1%
179.9982	1	< 0.1%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	518295
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.46483

Minimum	-84.422
Maximum	87.386
Zeros	9
Zeros (%)	< 0.1%
Negative	223047
Negative (%)	6.5%
Memory size	26.3 MiB

Quantile statistics

Minimum	-84.422
5-th percentile	-7.158
Q1	34.064
median	37.935667
Q3	47.848
95-th percentile	63.3374
Maximum	87.386
Range	171.808
Interquartile range (IQR)	13.784

Descriptive statistics

Standard deviation	20.415765
Coefficient of variation (CV)	0.54493148
Kurtosis	4.0482301
Mean	37.46483
Median Absolute Deviation (MAD)	4.7436667
Skewness	-1.6189768
Sum	1.2909448 × 10⁸
Variance	416.80348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.8216667	1186	< 0.1%
38.8195	975	< 0.1%
38.8146667	868	< 0.1%
38.8356667	864	< 0.1%
38.8218333	819	< 0.1%
38.8125	790	< 0.1%
38.8223333	774	< 0.1%
38.8221667	770	< 0.1%
38.823	763	< 0.1%
38.8211667	760	< 0.1%
Other values (518285)	3437182	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-84.422	1	< 0.1%
-84.133	1	< 0.1%
-83.902	1	< 0.1%
-82.8837	1	< 0.1%
-82.064	1	< 0.1%
-81.17	1	< 0.1%
-80.732	1	< 0.1%
-79.9837	1	< 0.1%
-77.36	1	< 0.1%
-77.134	1	< 0.1%

Value	Count	Frequency (%)
87.386	1	< 0.1%
87.3752	1	< 0.1%
87.092	1	< 0.1%
87.081	1	< 0.1%
87.051	1	< 0.1%
87.009	1	< 0.1%
87.008	1	< 0.1%
86.9964	1	< 0.1%
86.986	1	< 0.1%
86.979	1	< 0.1%

depth
Real number (ℝ)

ZEROS

Distinct	78386
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.853874

Minimum	-10
Maximum	735.8
Zeros	63714
Zeros (%)	1.8%
Negative	163316
Negative (%)	4.7%
Memory size	26.3 MiB

Quantile statistics

Minimum	-10
5-th percentile	0
Q1	3.12
median	7.7
Q3	16.12
95-th percentile	100
Maximum	735.8
Range	745.8
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	54.849379
Coefficient of variation (CV)	2.4000036
Kurtosis	56.921385
Mean	22.853874
Median Absolute Deviation (MAD)	5.34
Skewness	6.6779152
Sum	78748759
Variance	3008.4544
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	170770	5.0%
0	63714	1.8%
33	55936	1.6%
5	39390	1.1%
35	25132	0.7%
1	16950	0.5%
7	9318	0.3%
8	8296	0.2%
6	8087	0.2%
15	8057	0.2%
Other values (78376)	3040101	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10	5	< 0.1%
-6.8	1	< 0.1%
-5.6	1	< 0.1%
-4.7	1	< 0.1%
-4.6	1	< 0.1%
-4.5	1	< 0.1%
-3.9	1	< 0.1%
-3.882	1	< 0.1%
-3.816	1	< 0.1%
-3.812	1	< 0.1%

Value	Count	Frequency (%)
735.8	1	< 0.1%
721.8	1	< 0.1%
712.5	1	< 0.1%
712.2	1	< 0.1%
709.7	1	< 0.1%
700.9	1	< 0.1%
700.5	1	< 0.1%
700	7	< 0.1%
699	1	< 0.1%
698.1	1	< 0.1%

date
Text

Distinct	3428775
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	26.3 MiB

Length

Max length	32
Median length	32
Mean length	31.904616
Min length	25

Characters and Unicode

Total characters	109935361
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3411804 ?
Unique (%)	99.0%

Sample

1st row	1990-01-01 00:22:33.990000+00:00
2nd row	1990-01-01 00:24:51.210000+00:00
3rd row	1990-01-01 00:34:43.450000+00:00
4th row	1990-01-01 00:58:32.130000+00:00
5th row	1990-01-01 01:03:44.490000+00:00

Value	Count	Frequency (%)
2008-04-26	2587	< 0.1%
2008-04-27	2373	< 0.1%
2008-04-28	1747	< 0.1%
2020-10-01	1486	< 0.1%
2014-09-26	1449	< 0.1%
2008-04-25	1437	< 0.1%
2018-12-01	1383	< 0.1%
2008-05-03	1359	< 0.1%
2002-11-10	1326	< 0.1%
2021-06-06	1297	< 0.1%
Other values (3090933)	6875058	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	39338567	35.8%
:	10337253	9.4%
1	9691993	8.8%
2	9403006	8.6%
-	6891502	6.3%
3	4161835	3.8%
9	4057174	3.7%
4	3859638	3.5%
5	3843479	3.5%
	3445751	3.1%
Other values (5)	14905163	13.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109935361	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	39338567	35.8%
:	10337253	9.4%
1	9691993	8.8%
2	9403006	8.6%
-	6891502	6.3%
3	4161835	3.8%
9	4057174	3.7%
4	3859638	3.5%
5	3843479	3.5%
	3445751	3.1%
Other values (5)	14905163	13.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109935361	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	39338567	35.8%
:	10337253	9.4%
1	9691993	8.8%
2	9403006	8.6%
-	6891502	6.3%
3	4161835	3.8%
9	4057174	3.7%
4	3859638	3.5%
5	3843479	3.5%
	3445751	3.1%
Other values (5)	14905163	13.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109935361	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	39338567	35.8%
:	10337253	9.4%
1	9691993	8.8%
2	9403006	8.6%
-	6891502	6.3%
3	4161835	3.8%
9	4057174	3.7%
4	3859638	3.5%
5	3843479	3.5%
	3445751	3.1%
Other values (5)	14905163	13.6%

Auto

Heatmap
Table

	depth	latitude	longitude	magnitudo	significance	time	tsunami
depth	1.000	-0.017	0.016	0.409	0.408	0.089	0.018
latitude	-0.017	1.000	-0.561	-0.248	-0.248	0.131	0.005
longitude	0.016	-0.561	1.000	0.233	0.233	-0.175	-0.005
magnitudo	0.409	-0.248	0.233	1.000	1.000	-0.147	0.034
significance	0.408	-0.248	0.233	1.000	1.000	-0.146	0.035
time	0.089	0.131	-0.175	-0.147	-0.146	1.000	0.019
tsunami	0.018	0.005	-0.005	0.034	0.035	0.019	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	time	place	status	significance	data_type	magnitudo	state	longitude	latitude	depth	date
0	631153353990	12 km NNW of Meadow Lakes, Alaska	reviewed	96	earthquake	2.50	Alaska	-149.669200	61.730200	30.100	1990-01-01 00:22:33.990000+00:00
1	631153491210	14 km S of Volcano, Hawaii	reviewed	31	earthquake	1.41	Hawaii	-155.212333	19.317667	6.585	1990-01-01 00:24:51.210000+00:00
2	631154083450	7 km W of Cobb, California	reviewed	19	earthquake	1.11	California	-122.806167	38.821000	3.220	1990-01-01 00:34:43.450000+00:00
3	631155512130	11 km E of Mammoth Lakes, California	reviewed	15	earthquake	0.98	California	-118.846333	37.664333	-0.584	1990-01-01 00:58:32.130000+00:00
4	631155824490	16km N of Fillmore, CA	reviewed	134	earthquake	2.95	California	-118.934000	34.546000	16.122	1990-01-01 01:03:44.490000+00:00
5	631155853760	16km N of Fillmore, CA	reviewed	118	earthquake	2.77	California	-118.923000	34.543000	16.342	1990-01-01 01:04:13.760000+00:00
6	631156030570	6 km WSW of Mammoth Lakes, California	reviewed	20	earthquake	1.13	California	-119.040000	37.632667	-1.499	1990-01-01 01:07:10.570000+00:00
7	631156431950	12 km E of Mammoth Lakes, California	reviewed	11	earthquake	0.83	California	-118.834167	37.661500	0.556	1990-01-01 01:13:51.950000+00:00
8	631156614070	11 km E of Mammoth Lakes, California	reviewed	39	earthquake	1.59	California	-118.840167	37.662333	-0.234	1990-01-01 01:16:54.070000+00:00
9	631156620210	1 km W of Wilkeson, Washington	reviewed	74	earthquake	2.20	Washington	-122.071167	47.102500	8.382	1990-01-01 01:17:00.210000+00:00

	time	place	status	significance	data_type	magnitudo	state	longitude	latitude	depth	date
3445741	1690625310020	4 km SW of Redlands, CA	automatic	16	earthquake	1.01	California	-117.215500	34.030167	14.450	2023-07-29 10:08:30.020000+00:00
3445742	1690625393345	Southern Alaska	automatic	22	earthquake	1.20	Southern Alaska	-152.159400	60.104900	53.900	2023-07-29 10:09:53.345000+00:00
3445743	1690626164400	16 km ESE of Julian, CA	automatic	11	earthquake	0.85	California	-116.432833	33.035833	7.370	2023-07-29 10:22:44.400000+00:00
3445744	1690626699102	87 km NNW of Karluk, Alaska	automatic	15	earthquake	1.00	Alaska	-155.204500	58.241300	0.000	2023-07-29 10:31:39.102000+00:00
3445745	1690626815980	0 km SW of Universal City, CA	automatic	16	earthquake	1.03	California	-118.356833	34.135500	15.710	2023-07-29 10:33:35.980000+00:00
3445746	1690626851941	5 km NW of Chikusei, Japan	reviewed	326	earthquake	4.60	Japan	139.940200	36.350700	83.039	2023-07-29 10:34:11.941000+00:00
3445747	1690626975715	Kodiak Island region, Alaska	automatic	44	earthquake	1.70	Alaska	-153.729900	57.790100	24.400	2023-07-29 10:36:15.715000+00:00
3445748	1690627215940	12 km W of Alberto Oviedo Mota, B.C., MX	automatic	90	earthquake	2.42	B.C.	-115.296833	32.233167	1.770	2023-07-29 10:40:15.940000+00:00
3445749	1690628146040	7 km W of Cobb, CA	automatic	16	earthquake	1.03	California	-122.800499	38.827499	1.720	2023-07-29 10:55:46.040000+00:00
3445750	1690628937884	35 km W of Karluk, Alaska	automatic	12	earthquake	0.90	Alaska	-155.051000	57.564800	250.000	2023-07-29 11:08:57.884000+00:00

Most frequently occurring

	time	place	status	significance	data_type	magnitudo	state	longitude	latitude	depth	date	# duplicates
15193	1646108993805	54 km S of Whites City, New Mexico	reviewed	62	earthquake	2.00	New Mexico	-104.386630	31.682642	6.131567	2022-03-01 04:29:53.805000+00:00	4
16014	1646264543449	55 km S of Whites City, New Mexico	reviewed	81	earthquake	2.30	New Mexico	-104.401929	31.677717	7.288428	2022-03-02 23:42:23.449000+00:00	4
0	636249654650	3 km E of Mammoth Lakes, California	reviewed	42	earthquake	1.66	California	-118.933667	37.647000	3.816000	1990-03-01 00:00:54.650000+00:00	2
1	636249667890	4km N of Claremont, CA	reviewed	70	earthquake	2.13	California	-117.717000	34.133000	4.275000	1990-03-01 00:01:07.890000+00:00	2
2	636249694400	4km N of Claremont, CA	reviewed	62	earthquake	2.00	California	-117.717000	34.133000	4.275000	1990-03-01 00:01:34.400000+00:00	2
3	636249712400	5km NNE of Claremont, CA	reviewed	22	earthquake	1.20	California	-117.705000	34.144000	5.702000	1990-03-01 00:01:52.400000+00:00	2
4	636249724170	4km N of Claremont, CA	reviewed	160	earthquake	3.22	California	-117.714000	34.130000	5.622000	1990-03-01 00:02:04.170000+00:00	2
5	636249728970	4km NNE of Claremont, CA	reviewed	149	earthquake	3.11	California	-117.709000	34.134000	3.842000	1990-03-01 00:02:08.970000+00:00	2
6	636249751570	4km NNE of Claremont, CA	reviewed	110	earthquake	2.68	California	-117.709000	34.132000	3.372000	1990-03-01 00:02:31.570000+00:00	2
7	636249795280	4km NNE of Claremont, CA	reviewed	108	earthquake	2.65	California	-117.706000	34.133000	3.382000	1990-03-01 00:03:15.280000+00:00	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring